USE [ABC]
GO
/****** Object:  Table [dbo].[b2b]    Script Date: 09/18/2011 17:34:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[b2b](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Bid] [int] NOT NULL,
	[BBid] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[bb]    Script Date: 09/18/2011 17:34:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[bb](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nchar](50) NOT NULL,
	[InsertionDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[x]    Script Date: 09/18/2011 17:34:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[x](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[person]    Script Date: 09/18/2011 17:34:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[person](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[Character] [nvarchar](10) NOT NULL,
	[Favorite Color] [nvarchar](10) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[cc]    Script Date: 09/18/2011 17:34:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cc](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NULL,
	[bID] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[d]    Script Date: 09/18/2011 17:34:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[d](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NULL,
	[CCId] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DataObjectsII A]    Script Date: 09/18/2011 17:34:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DataObjectsII A](
	[MY ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DataObjectsII B]    Script Date: 09/18/2011 17:34:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DataObjectsII B](
	[MY ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[A ID] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DataObjectsII B To BB]    Script Date: 09/18/2011 17:34:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DataObjectsII B To BB](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[B ID] [int] NOT NULL,
	[BB ID] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DataObjectsII B To BBB]    Script Date: 09/18/2011 17:34:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DataObjectsII B To BBB](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[B ID] [int] NOT NULL,
	[BBB ID] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DataObjectsII BB]    Script Date: 09/18/2011 17:34:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DataObjectsII BB](
	[MY ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[A ID] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DataObjectsII BBB]    Script Date: 09/18/2011 17:34:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DataObjectsII BBB](
	[MY ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[A ID] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DataObjectsII BBBB]    Script Date: 09/18/2011 17:34:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DataObjectsII BBBB](
	[MY ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NULL,
	[Category] [nvarchar](50) NULL,
	[Code] [int] NULL,
	[DateCreated] [datetime] NOT NULL,
	[A ID] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DataObjectsII C]    Script Date: 09/18/2011 17:34:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DataObjectsII C](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[B ID] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[a]    Script Date: 09/18/2011 17:34:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[a](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[b]    Script Date: 09/18/2011 17:34:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[b](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NULL,
	[a ID] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[c]    Script Date: 09/18/2011 17:34:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[c](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NULL,
	[bID] [int] NOT NULL,
	[ts] [timestamp] NULL
) ON [PRIMARY]
GO
